using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
namespace QuanLyThietBi.Manager
{
                

    public class TBL_NguoiQuanLyManager:QuanLyThietBi.ManagerBase.TBL_NguoiQuanLyManagerBase
    {
            public static TBL_NguoiQuanLyManager CreateInstant()
            {
                return new TBL_NguoiQuanLyManager();
            }
            public DataTable LayDanhSachQuanLy()
            {
                string strsql = "select  ROW_NUMBER () Over (order by a.Manhomquanly) as STT,a.MaQuanLy, a.HoTen, a.DiaChi, a.DienThoai, a.Email, a.NgaySinh, b.TenNhomQuanLy from TBL_NguoiQuanLy a inner join TBL_NhomQuanLy b on a.MaNhomQuanLy= b.MaNhomQuanLy";
                return SqlHelper.ExecuteDataTable(Config.ConnectionConfig.ConnectionString, CommandType.Text, strsql);
            }

    }
}
                    
